Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$SEGMENT_STATISTICS

`V$SEGMENT_STATISTICS` displays information about segment-level statistics.

Column | Datatype | Description
--- | --- | ---
`OWNER` | `VARCHAR2(30)` | Owner of the object
`OBJECT_NAME` | `VARCHAR2(30)` | Name of the object
`SUBOBJECT_NAME` | `VARCHAR2(30)` | Name of the subobject
`TABLESPACE_NAME` | `VARCHAR2(30)` | Name of the table space to which the object belongs
`TS#` | `NUMBER` | Tablespace number
`OBJ#` | `NUMBER` | Dictionary object number of the object
`DATAOBJ#` | `NUMBER` | Data object number of the object
`OBJECT_TYPE` | `VARCHAR2(18)` | Type of the object
`STATISTIC_NAME` | `VARCHAR2(64)` | Name of the statistic
`STATISTIC#` | `NUMBER` | Statistic number
`VALUE` | `NUMBER` | Statistic value